Hello experts in VBA excel.
I have a excel sheet, with which my coworker collects data from the different audits, he is collecting it on diagonal form (upper left to bottom right), because the columns and rows content is changing all the time ( data collection)
So i would like to create a macro which is transposing the row information into column, and from diagonal to make a column.
how can i attach an excel sheet here, to show you what i mean ?
I have a excel sheet, with which my coworker collects data from the different audits, he is collecting it on diagonal form (upper left to bottom right), because the columns and rows content is changing all the time ( data collection)
So i would like to create a macro which is transposing the row information into column, and from diagonal to make a column.
how can i attach an excel sheet here, to show you what i mean ?