Data transformation

[anupgupta12]

Hi There!

I have a data set which has 15000 records but in one column but I need to create 15 columns consisting 1000 records each.

For example:-

Dataset:-

Column1

1

2

3

4

5

6

Outcome expected

Col1 Col2 Col3 Col4 Col5 Col6

1         2      3     4       5      6

[Emil_Kos]

Hi,

Make column tool will do the trick for you:

[Qiu · Accepted solution]

@anupgupta12 

A different approach with @Emil_Kos 

[anupgupta12]

Thanks Qiu, The formula is smart.  It will work on dynamic data as well.

Can you please share the the explanation of formula, what the formula actually doing here.

Why you did -1 and added +1?

[anupgupta12]

Thank you Emil, your formula will work too fast where number of columns are static. I have data set in which columns varies each time.

[Qiu]

@anupgupta12 
The manipulation is only to get the SN number from 1 to 15.
you can play around and see how it works.