Multiple data points recorded on one line but separated out into one database.

[PPriest]

I have a log sheet that I am having operators log downtime on. Each row represents 1 incident of downtime. They record the date, time, reason down and each tool that was changed at their machine.

What I would like to do is take each tool entry and place them all into one column in a different location so that I can sort by tool number and / reason. Thoughts?

 

[Candyman8019]

try: =TRANSPOSE(B2:E2) setting the range to the columns that you want to be displayed vertically.

 

[PPriest]

try: =TRANSPOSE(B2:E2) setting the range to the columns that you want to be displayed vertically.

Will this work for an ongoing / growing list?

 

[Candyman8019]

You would need to increment your range accordingly.

 

[PPriest]

You would need to increment your range accordingly.

Thanks, Candyman8019. I'll play with this. Looking for a solution that will auto grow the log sheet entries.

 

[PPriest]

Thanks, Candyman8019. I'll play with this. Looking for a solution that will auto grow the log sheet entries.

I should add that this data is in a Table so could a pivot chart do what I'm looking for? That is a weak spot for me.

 

[Candyman8019]

I also don't do much with Pivots, I'm sure there's a pivot expert on the board that can chime in

 

[PPriest]

I should add that this data is in a Table so could a pivot chart do what I'm looking for? That is a weak spot for me.

Could Power Query work for this?