JeffGrant
Well-known Member
- Joined
- Apr 7, 2021
- Messages
- 558
- Office Version
- 365
- Platform
- Windows
Hi All,
When I copy from a web database and paste to a single column in excel, I get data that appears as if in the first column. No drama.
For an explanation, I have added in a row.
If I use the index formula, in this case it relies upon the rows repeating every 12 rows to create a 2D array. No Problem.
The problem is that some times there is a row count of 13 and others a row count of 11, so the 2D array gets messed up.
I am looking for suggestion on how to handle this so that all the data ends up where it should in the same array column.
Because there is a login/password required for this database, the PQ functions cannot get passed the login screen.
I cannot control the number of rows for the copy function and the web database owner will not provide an export function, meaning that I have to handle this within Excel.
All suggestions are graciously recieved.
When I copy from a web database and paste to a single column in excel, I get data that appears as if in the first column. No drama.
For an explanation, I have added in a row.
If I use the index formula, in this case it relies upon the rows repeating every 12 rows to create a 2D array. No Problem.
The problem is that some times there is a row count of 13 and others a row count of 11, so the 2D array gets messed up.
I am looking for suggestion on how to handle this so that all the data ends up where it should in the same array column.
Because there is a login/password required for this database, the PQ functions cannot get passed the login screen.
I cannot control the number of rows for the copy function and the web database owner will not provide an export function, meaning that I have to handle this within Excel.
All suggestions are graciously recieved.
| Row Count | =INDEX($A$2:$A$521,(ROWS($1:1)-1)*12+COLUMNS(A:$A)) | |
| Name: Christine Foster | 12 | |
| Company: Donuts on Wheels | ||
| Email: donutsonwheels20@gmail.com | ||
| Phone: 61417774616 | ||
| Delivery to: 4130 QLD | ||
| Requirements: I have a Hot donut business and was thinking I needed something more. Thought a bench top one would be good | ||
| Product: IceTeam - Soft Serve Ice Cream, Frozen Yoghurt | G1 | ||
| Would consider different brands: Yes | ||
| Where this will be used: Commercial | ||
| Quantity: 1 | ||
| Needed in: Next few months | ||
| Date: 28 March 2022 | ||
| Name: Nick Powell | 13 | |
| Company: Oma’s Catering | ||
| Email: nickpow@bigpond.com | ||
| Phone: 0427020345 | ||
| Delivery to: 3000 VIC | ||
| Requirements: Ice cream van display freezer | ||
| Product: Tecfrigo - Ice Cream & Gelato Display | Microgel | ||
| Would consider different brands: Yes | ||
| Where this will be used: Hospitality | ||
| Quantity: 1 | ||
| Needed in: Next few months | ||
| Date: 18 March 2022 | ||
| Name: Nick Powell | 12 | |
| Company: Oma’s Catering | ||
| Email: nickpow@bigpond.com | ||
| Phone: 0427020345 | ||
| Delivery to: 3000 VIC | ||
| Requirements: [This buyer has indicated they are open to different suppliers and brands] | ||
| I am looking fora display freezer to go into front bench of new ice cream van | ||
| Product Category: Gelato & Ice Cream Display | ||
| Where this will be used: Hospitality | ||
| Quantity: 2 | ||
| Needed in: Next few weeks | ||
| Date: 18 March 2022 |
