matt-gilbert
Member
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
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