News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to convert columns...

Small and medium business | Business Central, N...

Unanswered

How to convert columns of one table to rows in another table in Business Central

(0) Share

Report

Report

Posted on by riya patel

80

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.

All responses Img

All responses (3)

Answers Img

Answers (0)

Lars Lohndorf-Larsen on at

Like (0)

Report

RE: How to convert columns of one table to rows in another table in Business Central

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
riya patel 80 on at

Like (0)

Report

RE: How to convert columns of one table to rows in another table in Business Central

Thank You for the reply ..But i want to achieve this using coding in AL could you please suggest in that direction
Lars Lohndorf-Larsen on at

Like (0)

Report

RE: How to convert columns of one table to rows in another table in Business Central

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.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2

Martin Dráb 230,466 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans