needs to be set-up once, can be refreshed afterwards.

or, as described below, using a QueryTable with some basic SQLĪ query table is basically a link to some external data (a textfile, a database, another excel-doc).

by looping your Table1- Range in the x and y direction (like you do).

by creating a Recordset, then looping it's records and field-names as shown in this example.

I recon there's a ton of ways to achieve this.

K, might aswell give you some hints on how I would do this based on the information I have. They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application.Assuming you use the Setup as shown in your example, this worked for me: Sub tt() Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date

Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data.

NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem.

Convert rows to columns in excel