Formula to display data of multiple columns in a horizontal order

[RAJESH1960]

Hello Everyone

The columns A to E is the original display of the data exported from a software.
I have to fill the whole data horizontally as shown in the image. But, the amount in column D, which are debit should be displayed in a negative figure and the amount in column E which are credit, should be displayed in a positive figure. Each date has a different data debit and credit wise. Hence the data should be compact without any blanks.
As this is a sample file with 3 entries only, I have manually posted the data just to show the result. (columns G to AB). I am trying to find a solution to display the data horizontally with the help of a formula, but I am not able to do so. I hope with the help of a formula, it is possible. My last option will be a VBA code,

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1	Original Data						To Display by a Formula or VBA code in the next sheet
2	Date	Particulars	Number	Debit	Credit		Date	A	B	C	Ledger Name	Amount (Dr)/Cr	Ledger Name	Amount (Dr)/Cr	Ledger Name	Amount (Dr)/Cr	Ledger Name	Amount (Dr)/Cr	Ledger Name	Amount (Dr)/Cr	Ledger Name	Amount (Dr)/Cr	Ledger Name	Amount (Dr)/Cr	Ledger Name	Amount (Dr)/Cr	Ledger Name	Amount (Dr)/Cr
3	01-02-2021	January	10001	100			01-02-2021		10001		January	-100	February	3600	March	-200	April	-300	May	-400	June	-500	July	-600	August	-700	September	-800
4		February			3600		02-02-2021		10002		January	-500	February	500
5		March		200			03-02-2021		10003		January	-100	March	-200	April	-300	Bank	650	CC	-50
6		April		300
7		May		400
8		June		500
9		July		600
10		August		700
11		September		800
12	02-02-2021	January	10002	500
13		February			500
14	03-02-2021	January	10003	100
15		March		200
16		April		300
17		Bank			650
18		CC		50
19
Sheet1

 

[RAJESH1960]

Good Morning,
I knew this was a tough one. So I hit the sack early.
I have cleaned the original data to make it simpler to apply a formula. I hope someone clearly understands what I am trying to get. Please note there are 2 sheets in this workbook and I am sending both the sheets.

Query to sort multiple data horizontally.xlsx
	A	B	C	D	E
1	DATE	PARTICULARS	NUMBER	DEBIT	CREDIT
2	01-02-2021	JANUARY	1001	-100
3	01-02-2021	FEBRUARY	1001		4300
4	01-02-2021	MARCH	1001	-300
5	01-02-2021	APRIL	1001	-400
6	01-02-2021	MAY	1001	-500
7	01-02-2021	JUNE	1001	-600
8	01-02-2021	JULY	1001	-700
9	01-02-2021	AUGUST	1001	-800
10	01-02-2021	SEPTEMBER	1001	-900
11	01-02-2021	JANUARY	1002	-500
12	01-02-2021	FEBRUARY	1002		500
13	02-02-2021	JANUARY	1003	-100
14	02-02-2021	MARCH	1003	-200
15	02-02-2021	APRIL	1003	-300
16	02-02-2021	BANK	1003		650
17	02-02-2021	CC	1003	-50
18		Total		-5450	5450
OriginalData

Cell Formulas
Range	Formula
D18:E18	D18	=SUM(D2:D17)

the other sheet where I want the data displayed after applying the formula

Query to sort multiple data horizontally.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	DATE	A	NUMBER	C	PARTICULARS	DR/CR AMOUNT	PARTICULARS	DR/CR AMOUNT	PARTICULARS	DR/CR AMOUNT	PARTICULARS	DR/CR AMOUNT	PARTICULARS	DR/CR AMOUNT	PARTICULARS	DR/CR AMOUNT	PARTICULARS	DR/CR AMOUNT	PARTICULARS	DR/CR AMOUNT	PARTICULARS	DR/CR AMOUNT	PARTICULARS	DR/CR AMOUNT
2	01-02-2021		1001		JANUARY	-100	FEBRUARY	4300	MARCH	-300	APRIL	-400	MAY	-500	JUNE	-600	JULY	-700	AUGUST	-800	SEPTEMBER	-900
3	02-02-2021		1002		JANUARY	-50	FEBRUARY	500
4	03-02-2021		1003		JANUARY	-100	MARCH	-200	APRIL	-300	BANK	650	CC	-50
Sorted Horizontally

 

[RAJESH1960]

Anybody home....Yu.Hu...

 

[RAJESH1960]

Anybody home....Yu.Hu...

I just watched a video about xlookup function. I think it may be possible to use that function for my problem, but the problem is, I have excel 2019 version and xlookup works in only 365.