I want to arrange the data in excel is there any way available arrange automatically.

I have data in these format is there any function or formula is available in excel to arrange data the way I want?

Apr May June
Rcpt No 656 656 656
Date 11-09-2021 11-09-2021 11-09-2021
Amount 123.00 124.00 123.00

Rcpt No 585 585 585
Date 21-08-2021 21-08-2021 21-08-2021
Amount 123.00 123.00 123.00

I want to arrange data in below format, I used transpose but it didn't work the way I want.

April May June
Rcpt No. Date Amount Rcpt No. Date Amount Recipt No. Date Amount
656 11-09-2021 123.00 656 11-09-2021 124.00 656 11-09-2021 123.00
585 21-08-2021 123.00 585 21-08-2021 123.00 585 21-08-2021 123.00

Welcome to the forum.

It would help if you attached a sample Excel workbook, as it is not very clear from your description how the data is laid out. You can do this by following the instructions in the yellow banner at the top of the screen.

Pete