Tardis
Board Regular
- Joined
- Dec 6, 2011
- Messages
- 108
Hi,
I've got a table with a unique ID and some text columns and some numbers for each month.
<tbody>
</tbody>
I need to convert it to this:
<tbody>
</tbody>
Where the Unique ID and Text is duplicated and the months are broken out with their numbers.
Using Paste Transpose for each row is not feasible as I have thousands of rows.
Help? How?
Thanks,
Byron
I've got a table with a unique ID and some text columns and some numbers for each month.
Unique ID | Text 1 | Text 2 | Apr | May | Jun |
567926 | ABC | zafads | 5 | 5 | 5 |
704740 | DE | fadf | 5 | 5 | 5 |
704765 | DE | aafds | 5 | 5 | 5 |
506511 | DE | adfa | 5 | 5 | 5 |
705258 | DE | adfa | 5 | 5 | 5 |
705259 | DE | afd | 5 | 5 | 5 |
705260 | DE | afd | 5 | 5 | 5 |
705261 | DE | afd | 5 | 5 | 5 |
705262 | DE | afd | 5 | 5 | 5 |
705263 | DE | afd | 5 | 5 | 5 |
<tbody>
</tbody>
I need to convert it to this:
567926 | ABC | zafads | Apr | 5 |
567927 | ABC | zafads | May | 5 |
567928 | ABC | zafads | June | 5 |
567929 | ABC | zafads | July | 5 |
567930 | ABC | zafads | Aug | 5 |
567931 | ABC | zafads | Sept | 5 |
<tbody>
</tbody>
Where the Unique ID and Text is duplicated and the months are broken out with their numbers.
Using Paste Transpose for each row is not feasible as I have thousands of rows.
Help? How?
Thanks,
Byron