Notifications
Announcements
Hello Experts,
I want to convert the data in columns of one table to data as rows in another column in Business Central.
Any help would be appreciated.
Thanks.
Hi,
Let me start with some ideas - depending on exactly what you need, maybe you can use Account Schedules: docs.microsoft.com/.../bi-how-work-account-schedule .
Or Export to Excel, and then to pivot table there or some other formatting.
Thank You for the reply ..But i want to achieve this using coding in AL could you please suggest in that direction
Back in history we had Matrix pages which included showing one table as header and one as lines. Now, Matrix pages are not around anymore but similar results can still be achieved. Maybe this has some ideas?
community.dynamics.com/.../how-to-create-a-matrix-page-in-business-central
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 1,957 Moderator
Dhiren Nagar 1,245 Moderator
YUN ZHU 1,045 Super User 2025 Season 2
