General Ledger excel file reconfiguration (from unstructured to structured db)


Do you have a workflow/recommendation for an excel database restructuring model? As you can see from the attachment, the purpose to transform the general ledger database from an unstructured format (having account correspondences vertically) to a structured database, where each line actually means something.

Any suggestions are helpful. thank you,

General Ledger reconfiguration-example.xlsx (11.2 KB)

Hello @GeorgeVP90
If the ID column is available as in provided file, this is a straight forward approach:

20230302_unstructured_excel_file_reconifg_to_structured_v0.knwf (58.2 KB)



Awesome. Thanks a lot, much appreciated

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.