Forum

Create spilled arra...
 
Notifications
Clear all

Create spilled array from non-contiguous columns in a table

2 Posts
2 Users
0 Reactions
32 Views
(@old-nuke)
Posts: 1
New Member
Topic starter
 

I have a table array. I'd like to extract data from non-contiguous columns (e.g., column a, d, f) and put them into a spilled array on another worksheet. I'll end up doing this a few times, and then creating a stacked table from the different spilled arrays. However, I can't figure out how to create the first spilled array. I'm sure it must be a syntax issue. 

I have searched the forum, but didn't see this issue. 

 
Posted : 04/09/2025 11:52 pm
Riny van Eekelen
(@riny)
Posts: 1303
Member Moderator
 

@old-nuke

I believe you can use CHOOSECOLS as demonstrated in the attached file.

 
Posted : 05/09/2025 12:11 am
Share: