Converting row to column

Question

Hi,

In my workflow I want to convert the below highlited Account number field into a column aligned with Rule name, Rule description column.

so that my output should look like

Any help on this?

Christina_H · Answer

@Tid14 Here's an updated version that will work for multiple files.  I've created both file IDs and row IDs, you might already have a different way to identify the files.

Row to column.yxmd

DawnDuong · Answer

hi @Tid14

Can you clarify "a wild card input for 20 csv files in single excel"?

Do you mean that

a) you have 20 different files that have the same format and you want to process them the same way?

Or b) you mean something else?

If your use case is (a) then you can get it done via a batch macro to process all files that exist in a specified folder. Check out this very useful thread on how to read multiple files: https://community.alteryx.com/t5/Engine-Works/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-ALL-Excel-Macro/ba-p/9988

Dawn.

Tid14 · Answer

Hi, Thanks

but what if this process is repeating mulitple times in the same excel.

I mean I have taken a wild card input for 20 csv files in single excel and evry file contains different account number

so i want these account numbers to be aligned for all 20 files.