Forum Discussion
data form huge number of worksheet
Hi , I have this excel document which was exported from a PDF, so the format was not exact great. it contains around 800 worksheet. In each worksheet it contains similar information which I n...
I created a workbook as per your inputs. refer book1.
then created a power query to find desired output as shown in book2.
check it out if it fulfils your requirement.