How to split Excel Data

[ganesh11k]

Hi All,

I have model wise, type wise and month wise data in table and i want to append in single table with additional column of type, kindly help,

Attached sample input and output for reference, thanks in advance.

[FinnCharlton · Accepted solution]

Hi @ganesh11k , this is one way to achieve your output. Hope it helps you out!

[OllieClarke · Accepted solution]

Edit: @FinnCharlton's is neater

Here's one way of doing it:

[FinnCharlton · Accepted solution]

@OllieClarke  But far less documented

[ganesh11k]

Hi thanks for the solution, i have updated sheet , can you share the solution for this one? Here i mean program as headers of table

[ganesh11k]

Hi thanks for the solution, i have updated sheet , can you share the solution for this one? Here i mean program as headers of table.

[OllieClarke · Accepted solution]

Hi @ganesh11k 

It took very few tweaks to update. I'm sure the same is true for @FinnCharlton's

Ollie