Identifying Groups of Data in a Column, Transposing Groups to a Row

[DHogue]

I have some data that was delivered to us in a tabular format, BUT it is all in one column. Each group consists of an item number (whole number), next row is date/time, next row is text, next row is a blank row. There is ALWAYS a blank row/cell between groups. I'd like to transpose each "group", so that the item number is in a column, the date/time is in a column and the text is in a column. The file is large so doing it manually is not a good option.

Does anyone have a method for accomplishing this task?

Thanks in advance.

 

[KRice]

You could try:

Book1
	A	B	C	D	E
1
2	1		1	45588	text1
3	10/23/2024		2	45595	text2
4	text1		3	45595.47	text3
5
6	2
7	10/30/2024
8	text2
9
10	3
11	10/30/2024 11:14
12	text3
13
Sheet1

Cell Formulas
Range	Formula
C2:E4	C2	=DROP(WRAPROWS(A2:A13,4),,-1)
Dynamic array formulas.

...and then format the date/time column to the preferred format.

 

[DHogue]

Oh my word!! That works beautifully! You are awesome. I appreciate your help. Thank you soooo much!!

 

[KRice]

Happy to help...and welcome to the MrExcel forum!