• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Convert pivot table back to database format

Hi all,
I have been provided with some data that appears to have been produced from a pivot table. The data (1 column, 22 rows) has also been provided with the original level (or indentation) number. What I am trying to achieve is to write one formula that can convert the data back into the original database format ie 7 columns, 9 rows. Refer attached. (this is only sample data, my real data is ~30,000 rows and forms part of a pricing schedule)
Any help would be really appreciated. Thanks in advance. Matt
 

Attachments

  • Convert pivot table back to database.xlsx
    14.6 KB · Views: 7
Back
Top