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!

Desired output_Alteryx.xlsx

Input_alteryx.xlsx

IraWatt

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%20Data

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

Workflow.yxmd