Generate Multiple Rows

One Star

Generate Multiple Rows

Hi,
I have data in excel like below columns e.g.
A1 B1 C1 1 11
A2 B2 C2 2 22
Need to transfor into following pattern.
A1 B1 C1 1
A1 B1 C1 2
A1 B1 C1 11
A1 B1 C1 22
A2 B2 C2 1
A2 B2 C2 2
A2 B2 C2 11
A2 B2 C2 22
I know I can read data from 1st to 3rd column and then read 4th to 5th column but my issue is then how to generate rows by multiplying rows with columns.
will appreciate any suggestion.
Thanks!
Seven Stars

Re: Generate Multiple Rows

There are many posts on the forum about creating multiple rows out of each input row, for example.
One Star

Re: Generate Multiple Rows

phew! finally got this...here is a tUnpivot plugin in order to achieve the format.