I am trying to get the data from several rows of a data table into a single cell. How can I do that? The table below in my code contains a single column and multiple records. I would like to get all the records into one cell and have the cell size vertically to accomodate the records. When I try the code below the data starts in the specified cell but there is a record in each cell below it. For example, if there are 3 records in the table, they populate cells E5 thru G5. I want all 3 records to end up in Cell E5 stacked vertically. How can that be done?
Well, Cells.ImportDataTable will extract data into tabular format and not in a single cell. If you want to do it, you have to manually extract the data and puts it into a single cell.
May the following example help you for your need, kindly consult it: