Transpose multiple groups of data in a loop from an Excel file.

[murugansundar]

Hi,

 I need to transpose the data: date-wise for every machine id & model. Please help me on how to do this transpose. I have attached a sample xls file.

[TomHH]

Hi Murugansundar,

See attached a solution based on my understanding of your need. The trick is to transpose the data so you have the column number references, fill down the date and join the dates to your transposed data using the column numbers as the join key. 

Please like this post if it was helpful so other can reference it!

Thanks

[murugansundar]

Thanks a lot. Still having some issues with the output data(found some repeated values) and I am trying o fix them. Will upload the fixed solution asap.

[alexnajm]

Awesome solution @TomHH!

[TomHH · Accepted solution]

Hi Murugansundar,

Yes I see - I think it's because of the null values throughout the data when using the multirow formula to fill the dates. I moved the multirow formula to after filtering out the dates which I think did the trick.

Thanks

[murugansundar · Accepted solution]

Awesome solution and Thanks a lot for the help.

[murugansundar]

Tom

Can I have your contact