Transform date from Horizontal to vertical (1 Viewer)

[NurulScare]

Hi, sorry since Im a newbie. i have lots of question to ask. I have data as below:

ID	QTY	DATE
A	100​	1/1/2021​
B	55​	2/1/2021​
C	60​	3/1/2021​

But I want to transform it become like below:

ID	1/1/2021​	2/1/2021​	3/1/2021​
A	100​
B		55​
C			60​

really need your help guyss! thanksss.. ❤

 

[plog]

What you want is a trivial cross-tab query:

Make summary data easier to read by using a crosstab query - Microsoft Support

Crosstab queries are useful for summarizing data, calculating statistics and then grouping the results.

support.microsoft.com

However, that just gets the data you want in the columnar layout you want. You posted this in the Reports section and cross-tab queries are very difficult to make into actual Access Reports. If you truly want something you can format and print in a pleasing to the eye manner, I suggest you accomplish what you want with a pivot table in Excel:

Create a PivotTable to analyze worksheet data - Microsoft Support

How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.

support.microsoft.com

Whats the end goal of this "report"?