Skip to main content
Question

Transposing multiple columns

  • October 10, 2019
  • 0 replies
  • 15 views

Forum|alt.badge.img

Hi All,

Thanks to all the experts for providing solution to my transposed doubt sometime back.

Here is an another challenge that i faced with now. I now have multiple columns instead of two.

where [A-R] are the required column names and the data from column 2 to last column should be the rows. Now i want two solutions:

1) Transpose only the given data in pic (must need)

2) The set of required columns (A-R) will repeat for the next file(when reading batch files) and needs to be given a common id and the entire data transposed. (optional)

 

Kindly help. Thanks

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.