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

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
You must log in or register to reply here.

Similar threads

A
  • Solved
adding extra lines to query removed all steps
Replies
8
Views
372
RoryA
RoryA
S
  • Question Question
Table.Expand duplicates some Files when using folder connect? Tried everything I know.
Replies
1
Views
320
GraH
GraH
D
  • Question Question
Power Query refresh taking HOURS after adding custom column
Replies
3
Views
2K
Matt Allington
M
L
  • Question Question
Help win unpivot super slow query
2
Replies
15
Views
1K
labello27
L
J
  • Question 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

Forum statistics

Threads
1,223,699
Messages
6,173,905
Members
452,536
Latest member
Chiz511

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