Condensing Columns - Not concatenating

[Marc22]

Hello,

I have approximately 381 columns that I would like to condense into 1. However, each value in these columns is unique so I do not want to concatenate the values. I want to have each value have its own row in this one main column. 

Is there a quick way to have all of these columns formatted into that first column (Npi Number) while keeping the values independent?  

*Note, although the columns showing have null values if I were to scroll down there would be actual values in the cells* 

[Lisa_P]

What is the purpose of this ?

[Vegar]

I'm not sure if I understand completely,  your sample data was without any values (?)

Maybe crosstable is what you are looking for.

Try this:

Data:

crosstable(newdimension, newvalue)

Load *

from Source;