![The best video editor app for iphone](https://cdn1.cdnme.se/5447227/9-3/15_64e61dfcddf2b36505b4c7c9.png)
![convert a row to a column in excel convert a row to a column in excel](https://media.gcflearnfree.org/ctassets/topics/175/new3_row_delete1.png)
![convert a row to a column in excel convert a row to a column in excel](https://www.chimpytech.com/wp-content/uploads/2014/09/Excel_Cells_Explained.png)
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).
![convert a row to a column in excel convert a row to a column in excel](https://i.ytimg.com/vi/QqoaCiC4MEU/maxresdefault.jpg)
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. Assuming you use the Setup as shown in your example, this worked for me: Sub tt()
![The best video editor app for iphone](https://cdn1.cdnme.se/5447227/9-3/15_64e61dfcddf2b36505b4c7c9.png)