Transposing row data into Columns five data at a time

[Adithya_S]

Hello Community,

I scraped data from web using below link,

https://www.census.gov/newsroom/press-releases/2018/estimates-cities.html

I have got the following output,

I am expecting to transpose every 5 record into column like below table,

Requesting you all to help me out here.

thanks in advance

[grazitti_sapna]

Hi @Adithya_S , can you possibly share your workflow or the sample file so that we can create you a mock workflow?

Thanks.

[Adithya_S]

Hello Sapna,

Thanks for replying,

I have attached my workflow.

[Emil_Kos]

Hi @Adithya_S,

I have prepared solution for you. 

It looks like I misunderstand your request

[grazitti_sapna · Accepted solution]

Hi @Adithya_S , here is my solution to the problem.

I hope this helps, kindly mark my post as solution if it solves your purpose.

Thanks.

[Qiu · Accepted solution]

@Adithya_S 

How about using Make Column Tool?

[Adithya_S]

Hello Sapna,

Thanks much, this is exactly what i wanted.

[Adithya_S]

Hello Qiu,

It was an easy and simple method, and it works,

Thanks.