Comment column is showing null

R

raj08536

Active Member
Joined
Aug 16, 2007
Messages
322
Office Version
  1. 365
Platform
  1. Windows
In StaleRevComments, I can see all the comments in the respective columns. These column have data type as TEXT.

= Table.ExpandTableColumn(Source, "StaleRevComments", {"Comments P05 F2022", "Comments P04 F2022", "Comments P03 F2022", "Comments P02 F2022", "Comments P01 F2022", "Comments P12 F2021", "Comments P11 F2021", "Comments P10 F2021", "Comments P09 F2021"})


However, I am getting null value

1632239848899.png


How to get comments populated in this query.
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
You must log in or register to reply here.

Similar threads

S
  • Question
Table.Expand duplicates some Files when using folder connect? Tried everything I know.
Replies
1
Views
142
GraH
GraH
D
  • Question
Power Query refresh taking HOURS after adding custom column
Replies
3
Views
292
Matt Allington
M
L
  • Question
Help win unpivot super slow query
2
Replies
15
Views
510
labello27
L
J
  • Question
Expression.Error: We cannot convert a value of type List to type Number.Details: Value=List Type=Type
Replies
0
Views
4K
jhazan
J
gheyman
  • Solved
I am trying to add a column if one does not already exist.
Replies
4
Views
437
GraH
GraH

Forum statistics

Threads
1,214,813
Messages
6,121,706
Members
449,049
Latest member
THMarana

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top