Need to repeat few columns and rows.Sharing the desired output for better understanding

[Vaibhav38855]

Hi, I have 1000+ rows of data and sharing a sample of one row where in I want the highlighted columns to become rows (they repeat after a set of 3) and the information on the left of the rows remain constant.Please refer to the input and desired output for one row.An urgent response would be appreciated.Thanks!

[IraWatt · Accepted solution]

Hey @Vaibhav38855,

Here is one way of doing this:

This solution uses the transpose, Cross Tab, and Regex tools which can be hard to understand to new users. I would recommend checking out the community Getting-Started-Learning-Path for some context on how they work: https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117#done  and https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20...

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[DataNath · Accepted solution]

Can't fit everything in the screenshot but seems to match the desired output:

[Vaibhav38855]

Thanks alot.This was really helpful and gave the desired output.